home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Agent Central Host Computer
/
Agent - Central Host Computer.iso
/
_SETUP.1
/
mrorphans.sql
< prev
next >
Wrap
Text File
|
2000-05-12
|
1KB
|
26 lines
/* RCSVER $Id: mrorphans.sql,v 1.1 1999-11-19 13:48:50-06 randy CURRENT $ */
/* *************************************************************************
* Copyright (C) 1998, Agent Systems, Inc. All Rights Reserved.
*
* Name: mrorphans.sql
* Date: 08/18/1999
* memo: Randy Wood
* Description: Create the mrorphans table. This table contains
* closed unmatched moneyroom counts.
* Changes:
************************************************************************* */
CREATE TABLE mrorphans
(
subbatch_seq NUMBER(38), /* Number of subbatch */
cashbox_glid NUMBER(38), /* cashbox number */
cb_sernum VARCHAR2(20), /* cashbox ID */
cbcount_date DATE, /* Date of count in money room */
count_coin_totals NUMBER(36,2),
count_bill_totals NUMBER(36,2),
count_amt NUMBER(36,2), /* Cash amount from moneyroom */
clbatch_num NUMBER(38), /* Close batch number */
comments VARCHAR2(500), /* User comments */
excp_num NUMBER(38), /* Exception number */
CONSTRAINT pk_mrorphans PRIMARY KEY (subbatch_seq)
);